package c.francis.mapper;
import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import c.francis.pojo.Member;
@Repository
public interface MemberMapper {
	/**
	 * ���������ѯ��Ա��Ϣ
	 */
	public Member queryMemberByEmail(String email);
	
	/**
	 * ע�����û�
	 */
//	public void insertNewMember(@Param("usrname")String username,@Param("email")String email,@Param("password")String password,@Param("regtime")Date regtime);
	public void	insertNewMember(String username,String	email,String	password,Date	regtime);
	/**
	 * �޸���ϵ����Ϣ
	 */
	public void updateLink(@Param("id")int id,@Param("name")String name,@Param("phone")String phone);
	
	/**
	 * �޸�����
	 */
	public void updatePwd(@Param("id")int id,@Param("newpassword")String newpassword);
	
	/**
	 * ͳ�ƻ�Ա��Ϣ
	 */
	public List<Member> queryAllMember(int pagestart);
	
	/**
	 * ��ѯ�ɷ�ҳ������
	 */
	public int countPage();

	public int updateTicketByEmail(String email,String ticket);

	public Member	findMemberByTicket(String ticket);
}
